CREATE TABLE engine_master(
seq INTEGER PRIMARY KEY AUTOINCREMENT,
title varchar2(30) NOT NULL default "",
short_title varchar2(10) NOT NULL default "",
url varchar2(100) NOT null default "",
useYn char(1) default "",
dp_seq INTEGER
);

CREATE TABLE engine(
seq INTEGER PRIMARY KEY AUTOINCREMENT,
book_seq INTEGER,
title varchar2(30) NOT NULL default "",
short_title varchar2(10) NOT NULL default "",
title_or_meaning varchar2(10) NOT NULL default "",
url varchar2(100) NOT null default "",
dp_seq INTEGER
);

CREATE TABLE tts(
seq INTEGER PRIMARY KEY,
country varchar2(30) NOT NULL default "",
lang varchar2(10) NOT NULL default ""
);

CREATE TABLE word_book(
seq INTEGER PRIMARY KEY,
book_name varchar2(20),
is_default char(1) default 'N',
is_last_used char(1) default 'N',
dporder int,
desc TEXT,
title_lang varchar2(30),
meaning_lang varchar2(30),
example_lang varchar2(30),
desc_lang varchar2(30),
alarm char(1),
quiz char(1),
deck char(1)
);

CREATE TABLE one_settings(
cur_version INTEGER,
once_run char(1) default "N",
once_restored char(1) default "N",
setting1 char(1),
setting2 char(1),
setting3 char(1),
setting4 int,
setting5 int,
setting6 int,
setting7 text,
setting8 text,
setting9 text
);

CREATE TABLE settings (
book_seq INTEGER PRIMARY KEY,
soundeffect TEXT DEFAULT 'Y',
wordbook TEXT DEFAULT 'A',
interval INTEGER DEFAULT 60,
title_locale TEXT DEFAULT 'en-US',
alarmsound TEXT DEFAULT 'Y',
lvl TEXT,
speed TEXT,
lvl1 TEXT DEFAULT 'on',
lvl2 TEXT DEFAULT 'on',
lvl3 TEXT DEFAULT 'on',
lvl4 TEXT DEFAULT 'on',
studiedyn TEXT DEFAULT 'N',
quizlvl1 TEXT DEFAULT 'on',
quizlvl2 TEXT DEFAULT 'on',
quizlvl3 TEXT DEFAULT 'on',
quizlvl4 TEXT DEFAULT 'on',
cellnotiyn TEXT DEFAULT 'N',
quizstudiedyn TEXT DEFAULT 'N',
quizwordbook TEXT DEFAULT 'A',
alarmtype TEXT default 'T',
readyn TEXT DEFAULT 'Y',
titleyn TEXT DEFAULT 'Y',
meaningyn TEXT DEFAULT 'Y',
exampleyn TEXT DEFAULT 'N',
starttime TEXT DEFAULT 'AM 9:00',
endtime TEXT DEFAULT 'PM 8:00',
nightmode TEXT DEFAULT 'N',
font TEXT DEFAULT '',
setting1 TEXT DEFAULT '',
setting2 TEXT DEFAULT '',
setting3 TEXT DEFAULT '',
setting4 TEXT DEFAULT '',
setting5 TEXT DEFAULT '',
meaning_locale varchar2(10) default 'ko-KR',
example_locale varchar2(10) default 'en-US',
first_card varchar2(2) default 'W',
first_view varchar2(2) default 'W',
card_order char(1) default 'R',--R Random, S sequential
first_book char(1) default 'L',--L last used, D default
first_quiz_index char(1) default '0',
quiz_cnt INTEGER DEFAULT 10,
deck_cnt INTEGER DEFAULT 10,
push_on_yn char(1) default 'Y',
--아래 3.2.5 버전
title_fontsize INTEGER DEFAULT 36,
title_lineheight INTEGER DEFAULT 12,
meaning_fontsize INTEGER DEFAULT 30,
meaning_lineheight INTEGER DEFAULT 12,
example_fontsize INTEGER DEFAULT 17,
example_lineheight INTEGER DEFAULT 6,
example_para char(1) DEFAULT 'N', --N Natural, J justify
example_para_vert char(1) DEFAULT 'T', --T top, M middle
goal_cnt integer default 3
);

CREATE TABLE words (
pk INTEGER PRIMARY KEY AUTOINCREMENT,
seq INTEGER,
book_seq INTEGER,
section TEXT, title TEXT, desc TEXT,
meaning TEXT, example TEXT, pronon TEXT,
lvl TEXT, locale TEXT, type TEXT,
done char(1) DEFAULT 'N', fav char(1) DEFAULT 'N', studiedyn char(1) DEFAULT 'N',
picture1 text,
picture2 text,
picture3 text,
--아래 3.2.5 버전
done_cnt integer default 0
);

create index idx_desc on words(desc);
create index idx_title on words(title);
create index idx_meaning on words(meaning);
